viii
Contents
viii
Chapter 5
The Organizer—Build Your Own Virtual Filing Cabinet....................81
5.1
The Algorithm...........................................................................81
5.2
Invoking the code......................................................................87
5.3
Conclusion................................................................................87
Chapter 6
Merging Sheets—Combine Multiple Workbooks of the
Same Format into One Workbook Automatically...............................89
6.1
Algorithm for merging sheets...................................................91
6.2
User Interface............................................................................91
6.3
Error Correction........................................................................95
6.4
Heavy Lifting............................................................................95
6.5
The Pickfile subroutine.............................................................98
6.6
Conclusion................................................................................98
Chapter 7
Introduction to Graphs—Create Your Own Interface
Diagram Instantly..............................................................................101
7.1
The Algorithm.........................................................................101
7.2
Conclusion..............................................................................116
Chapter 8
Shaping up—Analyze a Picture and Document Its
Components in Text...........................................................................119
8.1
The Algorithm.........................................................................119
8.2
List of Shapes..........................................................................121
8.3
Conclusion..............................................................................127
Chapter 9
Real-Time Currency Conversion—An Introduction to Simple
Web Scraping Techniques.................................................................129
9.1
Algorithm................................................................................129
9.2
Understanding the HTML.......................................................130
9.3
Output field.............................................................................131
9.4
The Algorithm.........................................................................132
9.5
Conclusion..............................................................................134
Chapter 10 The Genius of Collaboration—Build a Burglar Alarm Using
a Free Webcam Application...............................................................135
10.1 Ideas........................................................................................136
10.2 Burglar Alarm.........................................................................137
10.3 Counting People......................................................................137
10.4 Remote Photo..........................................................................138
10.5 Time based greeting................................................................138
10.6 Conclusion..............................................................................140